create table PR_PRProduct (
	productId decimal(20,0) not null primary key,
	productName varchar(75) null,
	serialNumber varchar(75) null,
	companyId decimal(20,0),
	groupId decimal(20,0)
)
go

create table PR_PRRegistration (
	registrationId decimal(20,0) not null primary key,
	prUserId decimal(20,0),
	datePurchased datetime null,
	howHear varchar(75) null,
	wherePurchased varchar(75) null,
	serialNumber varchar(75) null,
	productId decimal(20,0),
	companyId decimal(20,0),
	groupId decimal(20,0)
)
go

create table PR_PRUser (
	prUserId decimal(20,0) not null primary key,
	firstName varchar(75) null,
	lastName varchar(75) null,
	address1 varchar(75) null,
	address2 varchar(75) null,
	city varchar(75) null,
	state_ varchar(75) null,
	postalCode varchar(75) null,
	country varchar(75) null,
	phoneNumber varchar(75) null,
	email varchar(75) null,
	birthDate datetime null,
	gender varchar(75) null,
	userId decimal(20,0),
	companyId decimal(20,0),
	groupId decimal(20,0)
)
go
